| 2024-10-30 |
Karl O. Pinc | Add PEOPLE.Name and PEOPLE.Description RST substitutions |
commit | commitdiff | tree | snapshot |
| 2024-10-30 |
Karl O. Pinc | Add follows ER diagram |
commit | commitdiff | tree | snapshot |
| 2024-10-28 |
Karl O. Pinc | Use substitution instead of :ref: |
commit | commitdiff | tree | snapshot |
| 2024-10-28 |
Karl O. Pinc | Start sentences on a new line for diff readability |
commit | commitdiff | tree | snapshot |
| 2024-10-28 |
Karl O. Pinc | Note that diagrams use inkscape as their source file... |
commit | commitdiff | tree | snapshot |
| 2024-03-01 |
Stevan | fix biography.animidnum description |
commit | commitdiff | tree | snapshot |
| 2024-02-15 |
Karl O. Pinc... | Mark the UNK, unknown person, inactive to prevent futur... |
commit | commitdiff | tree | snapshot |
| 2024-02-15 |
Karl O. Pinc... | Add KL and KL_KK codes to COMM_IDS |
commit | commitdiff | tree | snapshot |
| 2024-02-15 |
Karl O. Pinc... | Use "UNK" unknown person when person is null |
commit | commitdiff | tree | snapshot |
| 2024-02-02 |
Karl O. Pinc... | Adjust conversion for new COMM_MEMBS_SOURCES table |
commit | commitdiff | tree | snapshot |
| 2024-02-02 |
Karl O. Pinc | Add COMM_MEMBS_SOURCES table |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Cache db content install per database |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc... | Adjust conversion to load BIOGRAPHY_DATA instead of... |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Create BIOGRAPHY view |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Add _error_immutable_view function to support un-update... |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Note how the table listing a view's columns should... |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Add DROP_EXISTING variable to for when there's no ... |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Fix so "make check" works after recreate-db target |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Add caution that remaking triggers or views drop triggers |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Change name of view dir to avoid name conflict with... |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Use consistent variable naming conventions |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Raise an exception if we don't find the view code |
commit | commitdiff | tree | snapshot |
| 2024-01-31 |
Karl O. Pinc | Automatically generate statements to drop views |
commit | commitdiff | tree | snapshot |
| 2024-01-30 |
Karl O. Pinc | Require that the CREATE VIEW explicitly list column... |
commit | commitdiff | tree | snapshot |
| 2024-01-30 |
Karl O. Pinc | Automatically generate statements to drop views |
commit | commitdiff | tree | snapshot |
| 2024-01-30 |
Karl O. Pinc | Fix (typos in) review target |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Change BIOGRAPHY table name to BIOGRAPHY_DATA |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Reflect change of lookup schema to "codes" in conversio... |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Change the name of the lookup schema to "codes" |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Improve code formatting |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Cleanup after moving triggers into db/schemas/lib/ |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Fix and imprprove error message |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Improve docs on clean targets |
commit | commitdiff | tree | snapshot |
| 2024-01-29 |
Karl O. Pinc | Add clean-commands target for scripts |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | default_transaction_deferrable=on, backslash_quote=off |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | The php-fpm interpreter is not deprecated |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Convert BIOGRAPHY_LOG |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Clean up "biography_update_log.made by" column to remov... |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Make a PEOPLE table in the "clean" schema to support... |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Index biography_log and comm_memb_log |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Add LIMIT to SELECT INTO, and ORDER BY for consistant... |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Fix AnimID column docs, must not be null, plus other... |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Create BIOGRAPHY_LOG and update docs with actual constr... |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Document BIOGRAPHY_LOG |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Remove empty trailing line |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Move DadID, DadIDPub, and DadPrelim relationships into... |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Mention both column names in the iff NULL docs |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Note what the special quotes are |
commit | commitdiff | tree | snapshot |
| 2024-01-24 |
Karl O. Pinc... | Add BIOGRAPHY.DadPrelim substitution refrence |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc | In diagram, change name BIOGRAPHY->BIOGRAPHY_DATA and... |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Reduce the HTML sidebar table of contents level to 2 |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc | Better docs for DATA_FILE conversion variable |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc | Remove more code which worked around invalid primary... |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | New limits ("final" for the ones that exist now) based... |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Update based on initial data conversion |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Enforce rule that EntryDate <= DepartDate |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Align community code max length with that of the code... |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Testing for contiguous membership requires membership... |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Fix syntax error |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Load DadIDPrelim; adjust DadID and DadIDPub accordingly |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Remove trailing newlines from file |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Do not limit AnimID length, to match BIOGRAPHY |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Add missing FROM clauses |
commit | commitdiff | tree | snapshot |
| 2024-01-19 |
Karl O. Pinc... | Fix minimum age of parent at time of birth calculation |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Cleanup data required to tidy data types, fixes problem #10 |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Improve description of file |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | These cleanups were done in the upstream data |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Explain why permissions are set only on raw |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Have BIOGRAPHY.DadIDPub follow the same NULL rules... |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Add BIOGRAPHY.DadID_Prelim column |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | New macro for if and only if NULL values |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Better BIOGRAPHY.DadID description |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Note where BIOGRAPHY.AnimIDs come from |
commit | commitdiff | tree | snapshot |
| 2024-01-18 |
Karl O. Pinc... | Reword the standard "empty text" phrasings |
commit | commitdiff | tree | snapshot |
| 2024-01-17 |
Karl O. Pinc... | Revert all code that changes the FOLLOW_MAP_TIME DDL... |
commit | commitdiff | tree | snapshot |
| 2024-01-17 |
Karl O. Pinc... | Do not change the FOLLOW_MAP_TIME DDL statement at all |
commit | commitdiff | tree | snapshot |
| 2024-01-17 |
Karl O. Pinc... | Properly pick up variables from the environment |
commit | commitdiff | tree | snapshot |
| 2024-01-17 |
Karl O. Pinc... | Improve docs for create-schema target |
commit | commitdiff | tree | snapshot |
| 2023-11-30 |
Karl O. Pinc | Progress towards moving demography data into a producti... |
commit | commitdiff | tree | snapshot |
| 2023-11-30 |
Karl O. Pinc | Fix max lifespan constraint |
commit | commitdiff | tree | snapshot |
| 2023-11-30 |
Karl O. Pinc | Change BIOGRAPHY.AnimIDNum to allow NULL, and fix const... |
commit | commitdiff | tree | snapshot |
| 2023-11-30 |
Karl O. Pinc | Fix column indexed |
commit | commitdiff | tree | snapshot |
| 2023-11-28 |
Karl O. Pinc | Allow spaces in Name column; align code with docs |
commit | commitdiff | tree | snapshot |
| 2023-11-28 |
Karl O. Pinc | Fix permissions |
commit | commitdiff | tree | snapshot |
| 2023-11-28 |
Karl O. Pinc | Fix comments |
commit | commitdiff | tree | snapshot |
| 2023-11-28 |
Karl O. Pinc | Convert data from the tidy to the easy schema |
commit | commitdiff | tree | snapshot |
| 2023-11-28 |
Karl O. Pinc | Fix to use command line argument |
commit | commitdiff | tree | snapshot |
| 2023-11-28 |
Karl O. Pinc | Require COMM_IDS.Name be unique |
commit | commitdiff | tree | snapshot |
| 2023-11-26 |
Karl O. Pinc | Improve hint; SokweDB has "admin"s and no real superusers |
commit | commitdiff | tree | snapshot |
| 2023-11-26 |
Karl O. Pinc | Document the "lib" schema |
commit | commitdiff | tree | snapshot |
| 2023-11-26 |
Karl O. Pinc | Fix typo |
commit | commitdiff | tree | snapshot |
| 2023-11-26 |
Karl O. Pinc | Move triggers and functions the user need not see into... |
commit | commitdiff | tree | snapshot |
| 2023-11-19 |
Karl O. Pinc | Do not need to remove primary key declaration, the... |
commit | commitdiff | tree | snapshot |
| 2023-11-12 |
Karl O. Pinc | Convert data into the tidy schema |
commit | commitdiff | tree | snapshot |
| 2023-11-09 |
Karl O. Pinc | Separate psql setup vars for different schemas |
commit | commitdiff | tree | snapshot |
| 2023-11-09 |
Karl O. Pinc | Stop if there's an error loading the db |
commit | commitdiff | tree | snapshot |
| 2023-11-09 |
Karl O. Pinc | Make executable |
commit | commitdiff | tree | snapshot |
| 2023-11-09 |
Karl O. Pinc | Change default conversion schema to "raw" |
commit | commitdiff | tree | snapshot |
| 2023-11-09 |
Karl O. Pinc | Separate file for db speed settings |
commit | commitdiff | tree | snapshot |
| 2023-11-09 |
Karl O. Pinc | Make "old" the default db for converting |
commit | commitdiff | tree | snapshot |
| next |
projects / kop_sokwedb / shortlog